UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K0r9y7msebu2NAi17OibHOpdDerzNtTW3eqmgQVCUVw='
WHERE
key_id = 'd214c5e7fdd35c8fa0711df62efe4b27702142d4cf695e6c18ee4ec3624a53d3'
AND (
token = 'K0r9y7msebu2NAi17OibHOpdDerzNtTW3eqmgQVCUVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)