UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'joPUoj3WPcOiVq+ePEpdrLLa1lL96dUNbg9HSd1izwU='
WHERE
key_id = '5870766bf875fb9ea1efcdcb31a388b7eda4a8bc4d293890f775c2c67aea9392'
AND (
token = 'joPUoj3WPcOiVq+ePEpdrLLa1lL96dUNbg9HSd1izwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)