UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vEIcK6lwLpDudme1Zv/yxVrdTLa7o1eUCqW1CUURQF4='
WHERE
key_id = 'd530cbe0e064f094995de1e44e05b6184f822079f647e3bca144e5084fefff3b'
AND (
token = 'vEIcK6lwLpDudme1Zv/yxVrdTLa7o1eUCqW1CUURQF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)