UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hNo+WnqxQFDr1Vr2J97Z7k0m1MccIMFlnYpwUtBvJGE='
WHERE
key_id = 'd7dc9f670789cc32b25a5c9e4456770c114e1f8d502c1026913434f480870083'
AND (
token = 'hNo+WnqxQFDr1Vr2J97Z7k0m1MccIMFlnYpwUtBvJGE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)