UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G5OhGXJNrKcBt3jP9FYRQs6sokb0b41bNe0eOkkXAYs='
WHERE
key_id = 'a4c7c96e5d9ce18ec685ef5113b25f8357d9b1835b711b9518a99c74e78ed5c1'
AND (
token = 'G5OhGXJNrKcBt3jP9FYRQs6sokb0b41bNe0eOkkXAYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)