UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5chtdAPzLIFMzuNf4USi6drjh4I/B9ZcwrGbPrELgPo='
WHERE
key_id = 'd589516b41ce9109ccdb9fd73a381f6666165ec41b89d3f375097e701ef04538'
AND (
token = '5chtdAPzLIFMzuNf4USi6drjh4I/B9ZcwrGbPrELgPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)