UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UI7p1383sYuh6NLAqZ8THFd5KPKDejURuU2fi+JzgvA='
WHERE
key_id = '3d0dcfbcd9e91919d0301d365a99f4a56797deb9f4789406104351b9b8e6e6ed'
AND (
token = 'UI7p1383sYuh6NLAqZ8THFd5KPKDejURuU2fi+JzgvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)