UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lB8j37lT8wEa6Z2BLo33BWgi6Afl6Ku38AuE0zQJAyA='
WHERE
key_id = 'c780f41e2b255409427d7f1d963e8626c32d371f68a9c54af1ec866c2ce859de'
AND (
token = 'lB8j37lT8wEa6Z2BLo33BWgi6Afl6Ku38AuE0zQJAyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)