UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BpYKHBRaNzaFd9+MbnsazkF7IK5R9TDGTq+J29Wxznw='
WHERE
key_id = '8bba5f627c706d028712c5f3cdbdc5d679606054e089aa43bb58b771eadac94f'
AND (
token = 'BpYKHBRaNzaFd9+MbnsazkF7IK5R9TDGTq+J29Wxznw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)