UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ha9BGht8LF4NLrstGP91F6A7ETrZL1KpPVGNUUkn/Rc='
WHERE
key_id = 'e7d4d334fe51188353417b152ee9ba5a39b095bc35d4cb0893258d3579dd4ac5'
AND (
token = 'Ha9BGht8LF4NLrstGP91F6A7ETrZL1KpPVGNUUkn/Rc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)