UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SHi1iSvJY8SJxhi8kdziiMcqxgrmV1DgQZ4ArfzYGis='
WHERE
key_id = 'd3f74cc1d1060f7f473f06f5288d8b2c3c3cefa44ba19fb24c3b9c0e1f26a3cf'
AND (
token = 'SHi1iSvJY8SJxhi8kdziiMcqxgrmV1DgQZ4ArfzYGis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)