UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27lVuxeUqyv4SWFcKXvGe0pPBWzoQA2eNA93/dMb5Nw='
WHERE
key_id = '4589e799024abfff00fa7659416a84babb3199353cdc87bb311d8e47c0070ba2'
AND (
token = '27lVuxeUqyv4SWFcKXvGe0pPBWzoQA2eNA93/dMb5Nw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)