UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yKLcDsjA9P9bC9ovYczVt7tGwjMQ7pPovcs+vwAKiyY='
WHERE
key_id = '78539ef8968301f377ea29514949d2c6400e6b2ee7204d922cfa4d2f90680916'
AND (
token = 'yKLcDsjA9P9bC9ovYczVt7tGwjMQ7pPovcs+vwAKiyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)