UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C5kNXkKwYFNLDF5I5H4nx+ljeKPUql/p9PssAaPQJzw='
WHERE
key_id = 'c6beffac1be70fc02b1949494b3d7316b81d3f431d9f3b7b0f1bde47e3e8acce'
AND (
token = 'C5kNXkKwYFNLDF5I5H4nx+ljeKPUql/p9PssAaPQJzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)