UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4lnT2BgCjmiI7lH9X9rTfJXNIOCN3ubmk3qrXNj9tic='
WHERE
key_id = 'b89c235250629a0b4ad2ce4be96307a6ebead4bf7434f041aad93e19c843ba19'
AND (
token = '4lnT2BgCjmiI7lH9X9rTfJXNIOCN3ubmk3qrXNj9tic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)