UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kHiZ3gaN9439PdK7BukTvE5ikw5VzCT2vJP67aHMlAI='
WHERE
key_id = '2af07de5a4bd68dbfef9e7962b773003f9a3a01a2122c199d807fa5a804b1cfc'
AND (
token = 'kHiZ3gaN9439PdK7BukTvE5ikw5VzCT2vJP67aHMlAI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)