UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cpjmYgLXyC6R0QGddg7J3ZsQLdsPjc88PDz6PuWJymM='
WHERE
key_id = '331113a9fad0d82dd60fa779dc2479b598786e3f4e50f2e490e396918b2793ab'
AND (
token = 'cpjmYgLXyC6R0QGddg7J3ZsQLdsPjc88PDz6PuWJymM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)