UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5RIBVK56R1nkOvLFPifcRZshDF0In147E0hjXfesMes='
WHERE
key_id = 'be95cdfe858ec0d63a09c2a8154e10ac623e45d8e40e506d953b56e5c36f49ca'
AND (
token = '5RIBVK56R1nkOvLFPifcRZshDF0In147E0hjXfesMes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)