UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PsyZ6o1co2WgD1nHLJo3icXJrBCUMOOMPrAEx1/XBGI='
WHERE
key_id = 'c67158a49daebe4c406ff7f7ee082cdf453547fc365d8ffe02c7b2c3a361e656'
AND (
token = 'PsyZ6o1co2WgD1nHLJo3icXJrBCUMOOMPrAEx1/XBGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)