UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRs7xqN6C3AgSIWcFb8B7AR4Mol3QVSYYptbmgC2spY='
WHERE
key_id = '8a56674828c7a8482023de80a8d5287693fd9ff69770504cc021a985059e3471'
AND (
token = 'KRs7xqN6C3AgSIWcFb8B7AR4Mol3QVSYYptbmgC2spY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)