UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n292oh0f1T4mNFsYx2r+U8LF1m37oqK9Tq1zswDIyC8='
WHERE
key_id = 'a5fef91451ca7ddb93fedd42056037428bf28a3a641f2e3196872bae830ee4a9'
AND (
token = 'n292oh0f1T4mNFsYx2r+U8LF1m37oqK9Tq1zswDIyC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)