UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XW65rL4fHk/9NHbCk4Ax1ACOLq3h/nMAKH3I5x4g+MY='
WHERE
key_id = '9f189be730becabb464ac82534ddd98f104539af5a151740228fbf63ccf13cd5'
AND (
token = 'XW65rL4fHk/9NHbCk4Ax1ACOLq3h/nMAKH3I5x4g+MY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)