UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hFxjAs+LyEBksMKWQO0TCFVdp8EcaLNN1Ao1qCgQ7tc='
WHERE
key_id = 'bcafd47275ebe4416311171cfb8cd58764f1713d7b10c65325d0b264b78cabdc'
AND (
token = 'hFxjAs+LyEBksMKWQO0TCFVdp8EcaLNN1Ao1qCgQ7tc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)