UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCZQyg687gb+WbJ+3DDj7TMfq2pRjLSJBQfcAev29wg='
WHERE
key_id = '514306d84684110970eb887469f030937b9254d9e29d1e1c1db3781bee6dbd94'
AND (
token = 'VCZQyg687gb+WbJ+3DDj7TMfq2pRjLSJBQfcAev29wg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)