UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rg/huSpHAwt1ha9boT4Qp+RYaH87ew+j/00NUuCwsTA='
WHERE
key_id = '0cfc720bb0e83b867f11c6deca1d8b276b9c2d9052b0aab9e783a12bdcd3a4b3'
AND (
token = 'rg/huSpHAwt1ha9boT4Qp+RYaH87ew+j/00NUuCwsTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)