UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'On9icUSzPhigfiT64yHFgfzQq/35xJXyT5SkSx9qOxQ='
WHERE
key_id = '6c8e181ac9bcf4d1c871248118a31fa9e32133f607b0e181fae1fae952c06ec1'
AND (
token = 'On9icUSzPhigfiT64yHFgfzQq/35xJXyT5SkSx9qOxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)