UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V9Dc650P+mTXV/ujvoAJrja3UQscuH4B+uBIZx4ERGM='
WHERE
key_id = '1484602c95813c0a21389f320786bae172c75e4546e8069aab65e2ab3082dcba'
AND (
token = 'V9Dc650P+mTXV/ujvoAJrja3UQscuH4B+uBIZx4ERGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)