UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7EsRp4Op5JEqgZmB71DZlXX7RgIS3+ZOvisazDxw1xQ='
WHERE
key_id = 'c78148e65e8bffe6cbaa9b1fed52e75e1a486ef3bad798db061f87e5e71f81c5'
AND (
token = '7EsRp4Op5JEqgZmB71DZlXX7RgIS3+ZOvisazDxw1xQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)