UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'diBkHJac/dpUYxVEI61qfRDW56pTfbw1xoS9O1VIoLg='
WHERE
key_id = '1fa540e8a39b3400d2c06f61d3476c0334d09081f699c03be11c8180538d16ad'
AND (
token = 'diBkHJac/dpUYxVEI61qfRDW56pTfbw1xoS9O1VIoLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)