UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HvjWp+SuRg7ipzZdgcyi0e/zrsyNU1mS0A3gyRyBVvE='
WHERE
key_id = '8cf7cb90ff54e479c5e181d7f07b5f67c66c1263da34f52e76a3c28016fbe4d5'
AND (
token = 'HvjWp+SuRg7ipzZdgcyi0e/zrsyNU1mS0A3gyRyBVvE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)