UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wOosvWBAruNIg2CGSVpOeqNhrz8eUDCngsPG7ms8Jkw='
WHERE
key_id = '78595853df42579fcdeb21d1afad12ed192af4fc929a562172322ffc6b96aee8'
AND (
token = 'wOosvWBAruNIg2CGSVpOeqNhrz8eUDCngsPG7ms8Jkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)