UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rNkyB55KfFPYhjwS73w8aE0m4w3NnnABq4gDSDEii7k='
WHERE
key_id = '47eb574ff08b0e43f3230df5e1177bdf03af1d6fb1f55cb5372faf1514e346f6'
AND (
token = 'rNkyB55KfFPYhjwS73w8aE0m4w3NnnABq4gDSDEii7k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)