UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bGD9diTfAwhZR8P/D6Uro/51tD08Q3lFVnFktfsufQg='
WHERE
key_id = 'b6e1c975db92537d13576c5f2c1b3ba54871d4a7e1af7e5161206b4c995c673f'
AND (
token = 'bGD9diTfAwhZR8P/D6Uro/51tD08Q3lFVnFktfsufQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)